package com.xyht.sca_s.student_manage_system.modules.chargePayment.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xyht.sca_s.student_manage_system.modules.chargePayment.entity.SmsWnsChargePaymentRecord;
import com.xyht.sca_s.student_manage_system.modules.chargePayment.entity.resp.TimeAndAmountResp;
import org.springframework.stereotype.Component;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * <p>
 * 缴费记录表 Mapper 接口
 * </p>
 *
 * @author XYHT
 * @since 2024-02-05
 */
@Component(value = "SmsWnsChargePaymentRecordMapper")
public interface SmsWnsChargePaymentRecordMapper extends BaseMapper<SmsWnsChargePaymentRecord> {

    List<TimeAndAmountResp> getTimeAndAmountEveryDay(Date startDate, Date endDate);

    List<TimeAndAmountResp> getTimeAndAmountEveryMonth(Date startDate, Date endDate);

    List<TimeAndAmountResp> getTimeAndAmountEveryYear(Date startDate, Date endDate);

    BigDecimal getTotalAmount(Date startDate, Date endDate);
}
